SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

/** Create Optimized Stored Procedures **/

create procedure dbo.DnnProduct_AddLink

	@ModuleId    int,
	@UserId      int,
	@Title       nvarchar(100),
	@Url         nvarchar(250),
	@ViewOrder   int,
	@Description nvarchar(2000)

as

insert into DnnProduct_Links (
	ModuleId,
	CreatedByUser,
	CreatedDate,
	Title,
	Url,
	ViewOrder,
	Description
)
values (
	@ModuleId,
	@UserId,
	getdate(),
	@Title,
	@Url,
	@ViewOrder,
	@Description
)

select SCOPE_IDENTITY()

GO
